Skip to main content

Maaşlar Sorgusu

User Salary Information Query in Synergy Environment​

This documentation describes how to access users' salary information in the Synergy environment. Below is the SQL query and details used to pull salary information.

SQL Query​

The following SQL query is used to pull salary information for specific users. This query returns records that have not been deleted (that is, salary information that is still valid).

Query Description:​

  • 'SALARIES' table: A table where users' salary information is kept.
  • The query uses the condition 'DELETEDAT IS NULL' to exclude deleted records.
  • Only active salary information is fetched.

Fields Used:​

  • 'USERID': The user's ID number.
  • 'STARTDATE': The date on which the salary starts.
  • 'ENDDATE': The date on which the salary ends.
  • 'FEE': The amount of salary.
  • 'CURRENCY': The currency of the salary.

SQL Query:​

'''SQL SELECT USERID, STARTDATE, ENDDATE, FEE, CURRENCY FROM SALARIES WHERE DELETEDAT IS NULL